RCG SAP S/4 HANA Customers System API - Implementation Template
Data mappings
This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.
contact-point-retrieve-response
Source:
./src/main/resources/dwl/contactpoints/contact-point-retrieve-response.dwl
Mapping Tables
contactPoints (ContactPointAddress) response mapping.
Resp Field | SAP HANA source field | Description of source field |
---|---|---|
contactPointType | NA | Set to "ContactPointAddress" |
id | AddressID | Address id in SAP HANA |
activeFromDate | NA | Set to current date |
addressLine1 | StreetName | Address street |
addressLine2 | HouseNumber | House Number |
cityName | HomeCityName | City name |
postalCodeText | PostalCode | Postal code |
stateProvinceName | Region | State |
countryName | Country | Country |
geoLatitude | NA | NA |
geoLongitude | NA | NA |
geoAccuracy | NA | NA |
contactPoints (ContactPointEmail) response mapping.
Resp Field | SAP HANA source field | Description of source field |
---|---|---|
contactPointType | NA | Set to "ContactPointEmail" |
id | AddressID | Address id in SAP HANA |
activeFromDate | ValidityStartDate | Validity start date |
emailAddress | EmailAddress | Email address |
contactPoints (ContactPointPhone) response mapping.
Resp Field | SAP HANA source field | Description of source field |
---|---|---|
contactPointType | NA | Set to "ContactPointEmail" |
id | AddressID | Address id in SAP HANA |
activeFromDate | NA | Set to current date |
telephoneNumber | PhoneNumber | Phone number |
search-customers-contact-point-retrieve-response
Source:
./src/main/resources/dwl/contactpoints/search-customers-contact-point-retrieve-response.dwl
Mapping Tables
contactPoints (ContactPointAddress) response mapping.
Resp Field | SAP HANA source field | Description of source field |
---|---|---|
contactPointType | NA | Set to "ContactPointAddress" |
id | AddressID | Address id in SAP HANA |
activeFromDate | NA | Set to current date |
addressLine1 | StreetName | Address street |
addressLine2 | HouseNumber | House Number |
cityName | HomeCityName | City name |
postalCodeText | PostalCode | Postal code |
stateProvinceName | Region | State |
countryName | Country | Country |
geoLatitude | NA | NA |
geoLongitude | NA | NA |
geoAccuracy | NA | NA |
contactPoints (ContactPointEmail) response mapping.
Resp Field | SAP HANA source field | Description of source field |
---|---|---|
contactPointType | NA | Set to "ContactPointEmail" |
id | AddressID | Address id in SAP HANA |
activeFromDate | ValidityStartDate | Validity start date |
emailAddress | EmailAddress | Email address |
contactPoints (ContactPointPhone) response mapping.
Resp Field | SAP HANA source field | Description of source field |
---|---|---|
contactPointType | NA | Set to "ContactPointEmail" |
id | AddressID | Address id in SAP HANA |
activeFromDate | NA | Set to current date |
telephoneNumber | PhoneNumber | Phone number |
create-customer-org-request
Source:
./src/main/resources/dwl/customers/create-customer-org-request.dwl
Mapping Tables
Search customers response mapping.
CIM Source Field | SAP target field | Description of target field |
---|---|---|
NA | BusinessPartnerCategory | Set to "2" for Organization |
NA | CorrespondenceLanguage | Set to "EN" |
NA | BusinessPartnerGrouping | Set to "BP02" |
party.name | BusinessPartnerName | Name of the Business Partner |
originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | Account Template |
primaryAccount | YY1_SME_ParentID_RTL_bus | Parent Id |
party.contactPoints | NA | Customer's address details |
externalIds.externalId | YY1_SME_MPARTYROLEID_bus | External Id |
OrganizationBPName1 | name | Name of the Organization |
to_BusinessPartnerAddress response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
activeFromDate | ValidityStartDate | Active from date |
addressLine1 | StreetName | Address street |
cityName | HomeCityName | City name |
postalCodeText | PostalCode | Postal code |
stateProvinceName | Region | State |
countryName | Country | Country |
geoLatitude | NA | NA |
geoLongitude | NA | NA |
geoAccuracy | NA | NA |
to_EmailAddress response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
emailAddress | EmailAddress | Email address |
to_PhoneNumber response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
telephoneNumber | PhoneNumber | Phone number |
to_BusinessPartnerRole response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
customerRole | BusinessPartnerRole | Role to be assigned to the customer |
to_CustomerSalesArea response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
salesOrganization | SalesOrganization | SalesOrganization |
distributionChannel | DistributionChannel | Distribution channel |
division | Division | Division |
create-customer-request
Source:
./src/main/resources/dwl/customers/create-customer-request.dwl
Mapping Tables
Search customers response mapping.
CIM Source Field | SAP target field | Description of target field |
---|---|---|
NA | BusinessPartnerCategory | Set to "1" for Persons |
NA | CorrespondenceLanguage | Set to "EN" |
NA | BusinessPartnerGrouping | Set to "BP02" |
party.firstName | FirstName | Customer's first name |
party.lastName | LastName | Customer's last name |
party.middleName | MiddleName | Customer's middle name |
party.birthDate | BirthDate | Customer's DOB |
party.contactPoints | NA | Customer's address details |
party.name | BusinessPartnerName | Name of the Business Partner |
originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | Account Template |
primaryAccount | YY1_SME_ParentID_RTL_bus | Parent Id |
externalIds.externalId | BusinessPartnerIDByExtSystem | External Id |
party.personName | PersonFullName | Person's full name |
to_BusinessPartnerAddress response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
activeFromDate | ValidityStartDate | Active from date |
addressLine1 | StreetName | Address street |
cityName | HomeCityName | City name |
postalCodeText | PostalCode | Postal code |
stateProvinceName | Region | State |
countryName | Country | Country |
geoLatitude | NA | NA |
geoLongitude | NA | NA |
geoAccuracy | NA | NA |
to_EmailAddress response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
emailAddress | EmailAddress | Email address |
to_PhoneNumber response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
telephoneNumber | PhoneNumber | Phone number |
to_BusinessPartnerRole response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
customerRole | BusinessPartnerRole | Role to be assigned to the customer |
to_CustomerSalesArea response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
salesOrganization | SalesOrganization | SalesOrganization |
distributionChannel | DistributionChannel | Distribution channel |
division | Division | Division |
update-customers-request
Source:
./src/main/resources/dwl/customers/update-customers-request.dwl
Mapping Tables
Search customers response mapping.
CIM Source Field | SAP target field | Description of target field |
---|---|---|
NA | BusinessPartnerCategory | Set to "1" for Persons |
NA | CorrespondenceLanguage | Set to "EN" |
NA | BusinessPartnerGrouping | Set to "BP02" |
party.firstName | FirstName | Customer's first name |
party.lastName | LastName | Customer's last name |
party.middleName | MiddleName | Customer's middle name |
party.birthDate | BirthDate | Customer's DOB |
party.contactPoints | NA | Customer's address details |
externalIds.externalId | BusinessPartnerIDByExtSystem | External Id |
party.personName | PersonFullName | Person's full name |
originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | AccountTemplate |
primaryAccount | YY1_SME_ParentID_RTL_bus | PrimaryAccount |
to_BusinessPartnerAddress response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
activeFromDate | ValidityStartDate | Active from date |
addressLine1 | StreetName | Address street |
cityName | HomeCityName | City name |
postalCodeText | PostalCode | Postal code |
stateProvinceName | Region | State |
countryName | Country | Country |
OrganizationBPName1 | name | name of the organization |
geoLatitude | NA | NA |
geoLongitude | NA | NA |
geoAccuracy | NA | NA |
to_EmailAddress response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
emailAddress | EmailAddress | Email address |
to_PhoneNumber response mapping.
CIM source Field | SAP HANA target field | Description of target field |
---|---|---|
telephoneNumber | PhoneNumber | Phone number |
retrieve-customer-by-id-response
Source:
./src/main/resources/dwl/customers/retrieve-customer-by-id-response.dwl
Mapping Tables
Retrieve customer by id response mapping.
Resp Field | SAP HANA source field | Description of source field |
---|---|---|
partyRoleType | NA | Set to "Customer" |
id | Customer | Customer id |
name | OrganizationBPName1 | name of the organization |
party | NA | Customer details |
party.id | Customer | Customer id |
party.salutation | NA | Customer salutation |
party.personName | FirstName and LastName | Customers full name |
party.firstName | FirstName | Customers first name |
party.lastName | LastName | Customers last name |
party.birthDate | BirthDate | Customers DOB |
party.partyType | NA | set to "Individual" |
party.contactPoints | NA | Customer's address details |
party.partyRole | to_BusinessPartnerRole | Customer's Roles |
party.partyRelatedParty | to_BPRelationship | Customer's Relationships |
party.accountOrgUnit | YY1_SME_OrgUnit_RTL_bus | Customer's Organization Unit Relationship |
party.users | to_BusinessPartnerContact | Customer's Contacts Relationship |
externalIds.id | NA | externalId id |
externalIds.externalId | BusinessPartnerIDByExtSystem | External Id |
externalIds.externalIdType | NA | set to "MDM" |
externalIds.statusLastChangedDate | LastChangeDate and LastChangeTime | Customer last modified datetime |
externalIds.status | NA | set to "VALID" |
auditInfo.createdDate | CreationDate and CreationTime | Customer creation date time in SAP |
auditInfo.createdBy | CreatedByUser | Customer created by |
auditInfo.updatedDate | LastChangeDate and LastChangeTime | Customer last modified datetime |
auditInfo.updatedBy | LastChangedUser | Last modified by |
auditInfo.isDeleted | NA | Is customer deleted |
customerNumber | BusinessPartner | Customer id |
customerStatus | NA | set to "ACTIVE" |
originatingCustomerSource | YY1_SME_AccouTemp_RTL_bus | AccountTemplate |
primaryAccount | YY1_SME_ParentID_RTL_bus | ParendId |